Packages

Packages are encapsulated collections of related procedures, stored functions, and other program objects stored together in the database. Package bodies, specified subsequently, defines these objects. An package consists of two parts: a specification and a body.

Just simply click -> Package to open an object pane for Package. A control-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit and delete the selected package.

Create Package (Package Specification)

To create a new package

Edit Package

To edit the existing package (manage its definition etc)

Delete Package

To delete a package

Create Package Body (Package Body)

To create a new package body

Edit Package Body

To edit the existing package body (manage its definition etc)

Run Package

To run a package in the object pane

  • Select the package for executing in the object pane.
  • Control-click and select Execute Package from the popup menu.
    or
  • Click the Excute from the object pane toolbar.
  • View the returned data on the Result tab.

To run a package in the Package Designer

  • Create a new package/open the existing package.
  • Click Run.
  • View the returned data on the Result tab.

Debug Package

To debug a package

To debug a package in the Package Designer

Maintain Package

To maintain a package

Achieve Package Information

To achieve a package information